﻿using System.Collections.Generic;
using Names = Citi.PTSConsolidation.Domain.EntrepotDatabaseNames.FinancialType;

namespace Citi.PTSConsolidation.Domain
{
    public partial class FinancialType
    {
        #region Mappings

        public static readonly Dictionary<string, string> ColumnMappings = new Dictionary<string, string>
        {
            {Names.AccountLevelId, "Id"},
            {Names.AccountLevel1, "AccountLevel1"},
            {Names.AccountLevel2, "AccountLevel2"},
            {Names.AccountLevel3, "AccountLevel3"},
        };

        #endregion

        #region Querystrings

        public static string EntrepotQueryString = string.Format(@"SELECT * FROM {0}",  Names.TableName);

        public const string QueryDuplicateData = "DELETE FROM FinancialTypeTemp";
        public const string MergeData = "EXEC spMergeFinancialType";

        #endregion
    }
}
